<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Editing a dataset report displayed as a grid</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:decimal; }
p.whs2 { margin-left:40px; }
ol.whs3 { list-style:disc; }
ol.whs4 { list-style:lower-alpha; }
p.whs5 { margin-left:0px; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs5 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying documents and dashboards\nCreating a document template: Grid/Graph controls\nEditing a dataset report displayed as a grid");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Editing a dataset report displayed as a grid</h1>
<p>Editing a dataset report on a document changes only the grid or graph 
 dataset in the document; it does not change the original report. To format 
 the Grid/Graph control that the dataset report is placed in, see 
<a href="Formatting_Grid_Graphs.htm">Formatting 
 Grid/Graphs</a>, which discusses borders, title bars, and quick switch, 
 among other properties.</p>
<p>You can change many settings of the grid. For example, you can change 
 the formatting of various rows and columns. You can change the sorting 
 or define totals or subtotals. You can select a different autostyle for 
 the grid, assign thresholds, and change various column settings.</p>
<h2>To edit a Grid/Graph in Grid view</h2>
<ol start="1" type="1" class="whs1">
	
<li class=p><p>Open a document in <span style="font-weight: bold;"><B>Design 
 </B></span>or <span style="font-weight: bold;"><B>Editable Mode</B></span>. </p></li>
	
<li class=p><p>Select the Grid/Graph to edit.</p></li>
</ol>
<p class="whs2"><span style="font-weight: bold;"><B>Note</B></span>: 
 If the Grid/Graph is a shortcut, you cannot edit it because it is linked 
 to the dataset report. A message appears, allowing you to choose whether 
 to unlink the shortcut. If you click OK, changes made to the dataset report 
 are no longer passed to the Grid/Graph in the document. &nbsp;</p>
<ol start="3" type="1" class="whs1">
	
<li class=p><p>To change the Autostyle for the whole grid, select the 
 new <span style="font-weight: bold;"><B>Autostyle</B></span> from the Grid toolbar. 
 </p></li>
	
<li class=p><p>To format a part of the Grid/Graph, right-click the 
 object in the grid and select <span style="font-weight: bold;"><B>Properties 
 and Formatting</B></span>. The Properties and Formatting dialog box opens. 
 For details, see 
<a href="Formatting_Grid_Graphs.htm">Formatting Grid/Graphs</a>.</p></li>
</ol>
<ol start="5" type="1" class="whs1">
	
<li class=p><p>To move an object, right-click the object in the grid, 
 select <span style="font-weight: bold;"><B>Move</B></span>, and then choose the 
 direction to move. </p></li>
</ol>
<ol start="6" type="1" class="whs1">
	
<li class=p><p>To insert a derived metric:</p></li>
</ol>
<ol type="disc" class="whs3">
	<ol type="a" class="whs4">
		
<li class=p><p>From the <span style="font-weight: bold;"><B>Data</B></span> 
 menu, select <span style="font-weight: bold;"><B>Insert</B></span> <span style="font-weight: bold;"><B>New 
 Metric</B></span>. The Insert New Metric dialog box opens.</p></li>
		
<li class=p><p>Create the derived metric. For details, see 
<a href="Creating_derived_metrics_documents.htm">Creating 
 derived metrics in documents</a>. </p></li>
		
<li class=p><p>Click <span style="font-weight: bold;"><B>OK</B></span>. 
 </p></li>
	</ol>
</ol>
<ol start="7" type="1" class="whs1">
	
<li class=p><p>To sort the grid:</p></li>
</ol>
<ol type="disc" class="whs3">
	<ol type="a" class="whs4">
		
<li class=p><p>Right-click the object in the Grid/Graph by which 
 to sort, point to <span style="font-weight: bold;"><B>Sort </B></span><span>and 
 select either </span><span style="font-weight: bold;"><B>Ascending</B></span> 
 or <span style="font-weight: bold;"><B>Descending</B></span>.</p></li>
		
<li class=p><p>For advanced sorting, from the right-click menu, 
 select <span style="font-weight: bold;"><B>Sort Grid</B></span>. The Sort Grid 
 dialog box opens. For steps to use this dialog box, see 
<a HREF="Sorting_data.htm">Sorting 
 report results</a>.</p></li>
	</ol>
</ol>
<ol start="8" type="1" class="whs1">
	
<li class=p><p>To add subtotals, right-click the Grid/Graph and select 
 <span style="font-weight: bold;"><B>Edit Totals</B></span>. The Subtotals dialog 
 box opens. For details, see 
<a HREF="Display_and_hide_totals.htm">Displaying 
 and hiding all totals</a>. </p></li>
</ol>
<ol start="9" type="1" class="whs1">
	
<li class=p><p>To change the width of a column, from the <span style="font-weight: bold;"><B>Home</B></span> 
 menu select <span style="font-weight: bold;"><B>Editable Mode</B></span>. Resize 
 the column by dragging and dropping the column's handle. For details, 
 see 
<a HREF="Resize_columns_and_rows.htm">Resizing columns and rows</a>.</p></li>
</ol>
<ol start="10" type="1" class="whs1">
	
<li class=p><p>To hide column and/or row headers:</p></li>
</ol>
<ol type="disc" class="whs3">
	<ol type="a" class="whs4">
		
<li class=p><p>Right-click the Grid/Graph and select <span style="font-weight: bold;"><B>Properties 
 and Formatting</B></span>. The Properties and Formatting dialog box opens.</p></li>
		
<li class=p><p>From the left, select <span style="font-weight: bold;"><B>Grid</B></span>. 
 Then clear the <span style="font-weight: bold;"><B>Show </B></span>check box(es) 
 in the appropriate columns.</p></li>
	</ol>
</ol>
<ol start="11" type="1" class="whs1">
	
<li class=p><p class="whs5">To display the grid in a static 
 version of outline mode, select the <span style="font-weight: bold;"><B>Outline</B></span> 
 check box. <span style="margin-left: 40px;">The rows and columns will 
 appear in an outline, but the user cannot collapse any of the rows. For 
 details on outline mode, see 
<a HREF="Using_Outline_Mode.htm">Outlining 
 data: Outline Mode</a>.</span></p></li>
</ol>
<p>For a complete list of grid formatting options, see 
<a HREF="adding_features_for_users.htm">Formatting 
 a grid report</a>.</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
